restore vt. 1.拿回原处,恢复原状;复旧;恢复;复活,复兴,再兴(制度、习惯等),使复位,使复职,使复辟。 2.归还。 3.修理,修补,重建,修复;再造,复原(古生物),补正,校补(书籍中的缺失文字等)。 4.使恢复健康[元气],使恢复意识。 restore order 恢复秩序。 restore to its owner (把拾物等)归还原主。 restore sb. to life 使人苏醒过来。 be restored out of all recognition 修复得一点也认不出。
Restoring the model and msdb databases restoring the 还原model数据库和msdb数据库
Database restore and roll forward must be done offline 数据库恢复和前滚必须脱机完成。
Performing a complete database restore full recovery model 执行数据库完整还原(完整恢复模式)
Performing a complete database restore simple recovery model 执行数据库完整还原(简单恢复模式)
Complete database restore 这些还原方案包括:
Database restore and roll forward does not necessary require the database be shutdown 数据库恢复和前滚不一定要求关闭数据库
Users can access databases when a partial database restore is being performed of a database file or page 用户在对数据库文件或页执行数据库部分还原时可访问数据库。
The following actions to the table are considered changes : insert , update , delete , index rebuild or defragmentation , and database restore or attach 对表的以下操作可视为更改:插入、更新、删除、索引重建或碎片整理以及数据库还原或附加。
Remember , a full database restore will require exclusive use for the entire restore operation , whereas online restore of a table space will only require that tablespace to be in exclusive mode 记住,完全数据库恢复将要求整个恢复操作具有排它性,而表空间的联机恢复将只要求表空间处于排它模式中。
In sql server 2005 , the partial option performs safety checks that are omitted by the partial database restore ; therefore , the resulting database is suited for use as a production database Partial选项只能出现在顺序内的第一条还原语句中。在后续的还原语句中使用partial将启动一个新的段落还原方案。